package com.youbang.bsMgr.user.dao;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import com.youbang.bsMgr.user.model.UserEntity;

@Mapper
@Repository
public interface UserMapper {
	
	@Select("SELECT * FROM t_user WHERE id=#{id}")
	UserEntity queryEntity(@Param("id") Long id) throws Exception;
	
	@Select("SELECT * FROM t_user WHERE loginId=#{loginId}")
	UserEntity queryEntityByLoginId(@Param("loginId") String loginId) throws Exception;
	
	@Select("SELECT * FROM t_user WHERE 1=1")
	List<UserEntity> queryList() throws Exception;
	
	
}
